Projects Pane Column Definitions

The Projects pane of the Cobra Explorer displays a set of standard columns.

You can change the way columns are shown by right clicking a column header and selecting an option from the shortcut menu. You can insert or edit a column in the Projects pane using the Insert Column dialog box and the Edit Column dialog box.

Column	Description	Formula
% Complete	This column displays the percentage of the work that has been completed.	(Earned/BAC * 100 )
% Spent	This column displays the percentage of the budget spent.	(Actuals / BAC) * 100
Actual Finish	This column displays the actual finish date of the project.	N/A
Actual Rate	This column displays the actual rate.	Actuals / Actuals Hours
Actuals	This column displays the total actual currency value of project. The Update Totals utility populates the value in the table.	N/A
Address	This column displays the address of the contractor.	N/A
AUW	This column displays the amount of any Authorized Unpriced Work (AUW) for the project.	N/A
BAC	This column displays the budget at completion or the resource total.	N/A
Baseline Finish	This column displays the baseline finish date that defines the last date of the project.	N/A
Baseline Start	This column displays the baseline start date that defines the initial status date for the project.	N/A
Baselined	This column indicates whether the project audit log has been turned on to set the baseline for the project.	N/A
Batch No.	This column displays the batch number that is stored in the time-phased and the project audit logs. Each time a process is run, the batch number is incremented.	N/A
Best Case EAC	This column displays the Estimated Cost at Completion (EAC) value for best-case forecasts displayed in the header of the IPMR reports. Use the Budget tab of the Project Properties dialog box to enter this value.	N/A
Budget	This column displays the total currency budget value of project. The Update Totals utility populates the value in the table.	N/A
Budget Rate	This column displays the budget rate.	Budget / Budget Hours
CA[1-3] Code File	This column displays the code files assigned to the control account.	N/A
CA[1-3] Key Term	This column displays the prompt that represents the code field.	N/A
Calendar File	This column displays the calendar file used in the project.	N/A
CAM Code Field No.	This column displays the CAM code field number.	N/A
Capture Actuals Level	This column displays the level at which you want to capture actual costs (Control Account, Work Package, or both Control Account and Work Package).	N/A
CBB	This column displays the Contract Budget Base (CBB) for the project, which is the combined Negotiated Cost and AUW.	N/A
Ceiling	This column displays the Budgeted and Estimate at Complete Contract Ceiling amounts for the project.	N/A
CCN Code File	This column displays the code file validating the change number.	N/A
CCN Use Code File	This column indicates whether there is a file validating the change number.	N/A
CCN Validation	This column displays the validation type.	N/A
Classification	This column displays the security classification of the contract, which is displayed on the top and bottom of the IPMR reports.	N/A
Complete	This column indicates that the project is already complete.	N/A
Contract Name	This column displays the name of the contract.	N/A
Contract Flag	This column displays the contract type.	N/A
Contract Number	This column displays the contract number.	N/A
Contract Phase	This column displays the project phase.	N/A
Contract Representative Name	This column displays the name of the person assigned to the contract.	N/A
Contract Representative Title	This column displays the title of the representative assigned to the contract.	N/A
Contract Type	This column displays the contract type, such as CPFF (Cost Plus Fixed Fee).	N/A
Contract Location	This column displays the location of the contractor.	N/A
Contractor Name	This column displays the contractor name, which is used on Cobra reports.	N/A
CostProject.EvmsAcceptanceId	This column indicates that the project passed EVMS validation. This is displayed in the header of the IPMR reports. Use the Project Properties dialog box to edit the contents of this field.	N/A
CostProject.IpmrFormat2Code	This column indicates that the IPMR Format 2 report uses an alternate code field.	N/A
CostProject.ProductVisibility	This column indicates that the project is visible in PM Compass.	N/A
CPI	This column displays the Cost Performance Index.	Earned / Actuals
CPI Performance	This column displays the CPI performance of the project.	Actuals/ Earned
CTC	This column displays the cost for the contract and all authorized changes as of a specific date. This amount usually includes any management reserves.	N/A
Currency Symbol	This column displays the currency symbol to be used to display costs in the Projects view and the Explorer view (for example, $ for dollars and € for Euros).	N/A
Currency Symbol on Right?	This column indicates whether the currency abbreviation (such as USD) is displayed to the right of any currency value.	N/A
CV	This column displays the Cost Variance.	Earned - Actuals
CV %	This column displays the Cost Variance percentage.	((Earned - Actuals) / Earned) * 100
Definite	This column displays the date the contract was made definite.	N/A
Description	This column displays a brief description of the project.	N/A
EAC	This column displays the total Estimate At Complete currency value of the project based on the cost set EAC. The Update Totals utility populates the value in the table.	N/A
Earned	This column displays the total earned currency value of the project. The Update Totals utility populates the value in the table.	N/A
Est. Ceiling	This column displays the estimated ceiling amount for the project. This is displayed on IPMR reports and can be edited in the Project Properties dialog box.	N/A
Est. MR	This column displays the estimated management reserve cost for the project. This is displayed on IPMR reports and can be edited in the Project Properties dialog box.	N/A
Est. UB	This column displays the estimated undistributed budget for the project. This is displayed on IPMR reports and can be edited in the Project Properties dialog box.	N/A
Estimated Price	This column displays the estimated Contract Target Price at the completion of the project. This is the sum of the Contract Budget Base and any management fees. This is displayed on IPMR reports and can be edited in the Project Properties dialog box.	N/A
EVMS Acceptance Date	This column displays the approval or disapproval date of the Earned Value Management System (EVMS) for the project. This is displayed on IPMR reports and can be edited in the Project Properties dialog box.	N/A
Fee	This column displays the management fee for the project. This is displayed on IPMR reports and can be edited in the Project Properties dialog box.	N/A
Fee Percent	This column displays the management fee for the project, expressed as a percentage of the Contract Budget Baseline.	N/A
Forecast Finish	This column displays the latest forecast finish date of the project.	N/A
Forecast Method Range 1 - 4	This column displays the forecast methods used for the class.	N/A
Hours % Complete	This column displays the percentage of the work that has been completed.	(Earned Hours / BAC Hours) * 100
Hours % Spent	This column displays the percentage of the budget spent.	(Actuals Hours / BAC Hours) * 100
Hours Actuals	This column displays the total actual currency value of the project in hours.	N/A
Hours BAC	This column displays the budget to date in hours.	N/A
Hours Budget	This column displays the budget to date in hours.	N/A
Hours CPI	This column displays the Cost Performance Index in hours.	Earned Hours / Actuals Hours
Hours CPI Performance	This column displays the CPI performance of the project in hours.	Actuals Hours / Earned Hours
Hours CV	This column displays the Cost Variance in hours.	Earned Hours - Actuals Hours
Hours CV %	This column displays the Cost Variance percentage.	((Earned Hours - Actuals Hours) / Earned Hours) * 100
Hours EAC	This column displays the total Estimate At Complete currency value of the project in hours.	N/A
Hours Earned	This column displays the total earned currency value of project in hours.	N/A
Hours iEAC	This column displays the independent Estimate At Complete in hours.	Actuals Hours + ((1 / CPI Hours) * (BAC Hours - Earned Hours))
Hours EAC2	This column displays the independent Estimate At Complete in hours.	Actuals Hours + ((1 / (CPI Hours * SPI Hours)) * (BAC Hours - Earned Hours))
Hours SPI	This column displays the Schedule Performance Index (SPI) in hours.	Earned Hours / Budget Hours
Hours SV	This column displays the Schedule Variance (SV) in hours.	Earned Hours - Budget Hours
Hours SV %	This column displays the Schedule Variance (SV) percentage.	((Earned Hours - Budget Hours) / Budget Hours) * 100
Hours TCPI	This column displays the To Complete Performance Index (TCPI) in hours.	(BAC Hours - Earned Hours)/ (EAC Hours - Actual Hours).
Hours TCPI BAC	This column displays the To Complete Performance Index within the project budget at complete in hours.	(BAC Hours - Earned Hours) / (BAC Hours - Actuals Hours)
Hours VAC	This column displays the Variance At Complete (VAC).	BAC Hours - EAC Hours
Hours VAC %	This column displays the Variance At Complete (VAC) percentage.	((BAC Hours - EAC Hours) / BAC Hours) * 100
Hours Variance	This column displays the Variance in hours.	Budget Hours - Actuals Hours
iEAC	This column displays the independent Estimate At Complete.	Actuals + ((1 / CPI) * (BAC - Earned))
iEAC2	This column displays the independent Estimate at Complete.	Actuals + ((1 / (CPI * SPI)) * (BAC - Earned))
Last Updated	This column displays the date and time when a record was last updated. The Last Updated field exists on many tables in Cobra but not all. A record may be changed because of a direct change by the user against that record, or because of an indirect change. Example of a Direct Change A user modifies the description of a control account, which causes the control account's description field to be updated on the record. As a result, the Last Updated field is also updated. Example of an Indirect Change A user modifies the total budget of a resource assignment on a work package. The total budget stored on the work package is updated, the total budget stored on the control account is updated, and the total budget stored on the project is updated. The work package, control account, and project records will each get an updated Last Updated value even if they were not directly edited because the total budget stored on each record was updated. Note: In some cases, Cobra displays values that are not stored directly on the record. It may appear a record has changed values but internally, Cobra is displaying a calculated value and therefore, the record's Last Updated field will not change.	N/A
LRE	This column displays the Latest Revised Estimate At Completion (LRE), which is the updated and most recent Estimate at Completion (EAC).	N/A
Manager Code File	This column displays the code file validating the manager (CAM) code.	N/A
Manager Code File Type	This column displays the code file type validating the manager CAM code.	N/A
Manager Validation	This column indicates that there is a code file validating the manager.	N/A
Master Project Flag	This column indicates that the project is a master project.	N/A
MPS CODE	This column displays the project level in the database.	N/A
MR	This column displays the budgeted and estimated final management reserve for the project.	N/A
Open Plan Project	This column displays the Open Plan project used by the Cobra project.	N/A
OTB	This column displays the baseline which results from formal reprojecting of an overrun, used only with the approval of the customer.	N/A
OTB Date	This column displays the date when OTB was allocated to the project.	N/A
OTC	This column displays the Original Negotiated Cost value.	N/A
Percent Range 1 – 3	This column displays the range used for the forecast method. The range varies based on % Complete.	N/A
Period Start Date	This column displays the previous status date used in report headers.	N/A
Project	This column displays the name of the project.	N/A
Project Code 1 - 9	This column displays the project level codes for the project.	N/A
Quantity	This column displays the number of items to be procured for the contract.	N/A
Rate File	This column displays the rate file used for the project.	N/A
Resource Code File	This column displays the resource code file used for the project.	N/A
Resource Key Term	This column displays the resource field name.	N/A
Resource File	This column displays the resource file used for the project.	N/A
Rolling Wave Calendar	This column displays the rolling wave calendar used for the project.	N/A
Scale Caption	This column displays the caption for the scale factor that appears in the reports.	N/A
Scale Factor	This column displays the scale factor that will be used to report currency amounts.	N/A
Sequence	This field is used internally by Cobra.	N/A
Share Ratio	This column displays the share ratio for the contract.	N/A
SPI	This column displays the Schedule Performance Index.	Earned / Budget
Spread Weight Method	This column displays the spread weight method.	N/A
State	This column displays the state where the contractor is located.	N/A
Status Date	This column displays the status date of the project.	N/A
SV	This column displays the Schedule Variance.	Earned - Budget
SV %	This column displays the Schedule Variance percentage.	((Earned - Budget) / Budget) * 100
Target Price	This column displays the estimated Contract Target Price at the completion of the project. This is the sum of the Contract Budget Base and any management fees.	N/A
TCPI	This column displays the To Complete Performance index.	(BAC - Earned) / (EAC - Actuals)
TCPI BAC	This column displays the To Complete Performance index within the project budget at complete.	(BAC - Earned) / (BAC - Actuals)
UB	This column displays the Undistributed Budget. Undistributed Budget. This is the budget applicable to contract effort which has not yet been identified to Contract Work Breakdown Structure (CWBS) elements at or below the lowest level of reporting to the government.	N/A
User	This column displays the individual who is currently accessing the project.	N/A
VAC	This column displays the Variance At Complete.	BAC - EAC
VAC %	This column displays the Variance At Complete percentage.	((BAC - EAC) / BAC) * 100
Variance	This column displays the Variance.	Budget - Actuals
Worst Case EAC	This column displays the Estimated Cost at Completion (EAC) value for worst-case forecasts. Use the Budget tab of the Project Properties dialog box to enter this value.	N/A
WP Code File	This column displays the work package code file assigned to the project.	N/A
WP Key Term	This column displays the work package field name.	N/A
Zip	This column displays the zip code where the contractor is located.	N/A